package jsyf.oa.entity.device;

import com.alibaba.fastjson.JSONObject;
import jsyf.oa.entity.attach.AttachmentEntity;
import jsyf.oa.ientity.BaseEntity;

import javax.persistence.Entity;
import javax.persistence.Table;
import java.math.BigDecimal;
import java.util.Date;

/**
 * Created by LT on 2018/4/14.
 */
@Entity
@Table(name = "T_DVC_SAMPLE", schema = "oa", catalog = "")
public class DeviceSampleMainEntity extends BaseEntity {


    private String fkBrandId;
    private String brandName;
    private String fkDeviceTypeId;
    private String deviceTypeName;
    private String fkModelId;
    private String modelName;
    private String sequence;
    private String state;
    private String storeAddress;
    private String pickUpDate;
    private String fkCompanyId;
    private String companyName;
    private String pickUpAddress;
    private String pickUpType;
    private String trafficDestination;
    private String trafficStarting;
    private String trafficFee;
    private String trafficCompany;
    private String orderSupport;
    private String remark;
    private String certificationAttachName;
    private String certificationAttachUrl;
    private String namePlateAttachName;
    private String namePlateAttachUrl;
    private String driverAttachName;
    private String driverAttachUrl;
    private String invoiceAttachName;
    private String invoiceAttachUrl;
    private BigDecimal tonConfig;

    private String bucketType;
    private String productionDate;
    private String storeDuration;
    private String financing;
    private String payment;
    private BigDecimal pickupPrice;
    private BigDecimal partsPrice;
    private String partsRemark;
    private String paymentStatus;
    private String settle;
    private String freeMaturityDate;
    private String factoryContacts;
    private String factoryTel;
    private String shuttleContacts;
    private String shuttleTel;
    private String transportCompany;
    private String contacts;
    private String telephone;
    private String drayLicense;
    private String deliveryAddress;
    private String driverName;
    private String driverTel;

    private String picture;
    private BigDecimal specialFee;
    private BigDecimal deductionFee;
    private String deductionRemark;
    private Date createTime;
    //private Date updateTime;
    private String drillDiameter;
    private String maxCapacity;
    private String stockTime;
    private String transportStartTime;
    private String transportEndTime;

    private String auditName;
    private String auditId;
    private Integer auditFlag;
    private String createUserId;
    private String createUserName;
    //private String updateUserId;
    private String updateUserName;
    private String auditAdvise;
    private String auditRoleName;
    private Date auditTime;

    private String regionId;
    private String regionName ;
    private String regionManagerId ;
    private String regionManagerName ;
    private String bigregionManagerId ;
    private String bigregionManagerName ;
    private String recentContactDate;
    private String latestWorkingHours;
    private String deviceSource;
    private String warrantyState;
    private String administratorName;
    private String administratorPhone;
    private String operatorName;
    private String operatorPhone;
    private String servicePersonnel;
    private String engineNumber;
    private String nextServiceDate;
    private String cooperationType;
    private String actualDeliveryDate;

    private String provinceName;
    private String cityName;
    private String countyName;
    private String accessoriesRemark;

    private String partsAttachName;
    private String partsAttachUrl;
    private String deviceParts;
    private String description;
    private String deviceAnnex;
    public String getCooperationType() {
        return cooperationType;
    }

    public void setCooperationType(String cooperationType) {
        this.cooperationType = cooperationType;
    }

    public String getRegionId() {
        return regionId;
    }

    public void setRegionId(String regionId) {
        this.regionId = regionId;
    }

    public String getRegionName() {
        return regionName;
    }

    public void setRegionName(String regionName) {
        this.regionName = regionName;
    }

    public String getRegionManagerId() {
        return regionManagerId;
    }

    public void setRegionManagerId(String regionManagerId) {
        this.regionManagerId = regionManagerId;
    }

    public String getRegionManagerName() {
        return regionManagerName;
    }

    public void setRegionManagerName(String regionManagerName) {
        this.regionManagerName = regionManagerName;
    }

    public String getBigregionManagerId() {
        return bigregionManagerId;
    }

    public void setBigregionManagerId(String bigregionManagerId) {
        this.bigregionManagerId = bigregionManagerId;
    }

    public String getBigregionManagerName() {
        return bigregionManagerName;
    }

    public void setBigregionManagerName(String bigregionManagerName) {
        this.bigregionManagerName = bigregionManagerName;
    }

    public String getRecentContactDate() {
        return recentContactDate;
    }

    public void setRecentContactDate(String recentContactDate) {
        this.recentContactDate = recentContactDate;
    }

    public String getLatestWorkingHours() {
        return latestWorkingHours;
    }

    public void setLatestWorkingHours(String latestWorkingHours) {
        this.latestWorkingHours = latestWorkingHours;
    }

    public String getDeviceSource() {
        return deviceSource;
    }

    public void setDeviceSource(String deviceSource) {
        this.deviceSource = deviceSource;
    }

    public String getWarrantyState() {
        return warrantyState;
    }

    public void setWarrantyState(String warrantyState) {
        this.warrantyState = warrantyState;
    }

    public String getAdministratorName() {
        return administratorName;
    }

    public void setAdministratorName(String administratorName) {
        this.administratorName = administratorName;
    }

    public String getAdministratorPhone() {
        return administratorPhone;
    }

    public void setAdministratorPhone(String administratorPhone) {
        this.administratorPhone = administratorPhone;
    }

    public String getOperatorName() {
        return operatorName;
    }

    public void setOperatorName(String operatorName) {
        this.operatorName = operatorName;
    }

    public String getOperatorPhone() {
        return operatorPhone;
    }

    public void setOperatorPhone(String operatorPhone) {
        this.operatorPhone = operatorPhone;
    }

    public String getServicePersonnel() {
        return servicePersonnel;
    }

    public void setServicePersonnel(String servicePersonnel) {
        this.servicePersonnel = servicePersonnel;
    }

    public String getEngineNumber() {
        return engineNumber;
    }

    public void setEngineNumber(String engineNumber) {
        this.engineNumber = engineNumber;
    }

    public String getNextServiceDate() {
        return nextServiceDate;
    }

    public void setNextServiceDate(String nextServiceDate) {
        this.nextServiceDate = nextServiceDate;
    }

    public String getAuditName() {
        return auditName;
    }

    public void setAuditName(String auditName) {
        this.auditName = auditName;
    }

    public String getAuditId() {
        return auditId;
    }

    public void setAuditId(String auditId) {
        this.auditId = auditId;
    }

    public Integer getAuditFlag() {
        return auditFlag;
    }

    public void setAuditFlag(Integer auditFlag) {
        this.auditFlag = auditFlag;
    }

    public String getUpdateUserName() {
        return updateUserName;
    }

    public void setUpdateUserName(String updateUserName) {
        this.updateUserName = updateUserName;
    }

    public String getAuditAdvise() {
        return auditAdvise;
    }

    public void setAuditAdvise(String auditAdvise) {
        this.auditAdvise = auditAdvise;
    }


    public String getFkBrandId() {
        return fkBrandId;
    }

    public void setFkBrandId(String fkBrandId) {
        this.fkBrandId = fkBrandId;
    }

    public String getBrandName() {
        return brandName;
    }

    public void setBrandName(String brandName) {
        this.brandName = brandName;
    }

    public String getFkDeviceTypeId() {
        return fkDeviceTypeId;
    }

    public void setFkDeviceTypeId(String fkDeviceTypeId) {
        this.fkDeviceTypeId = fkDeviceTypeId;
    }

    public String getDeviceTypeName() {
        return deviceTypeName;
    }

    public void setDeviceTypeName(String deviceTypeName) {
        this.deviceTypeName = deviceTypeName;
    }

    public String getFkModelId() {
        return fkModelId;
    }

    public void setFkModelId(String fkModelId) {
        this.fkModelId = fkModelId;
    }

    public String getModelName() {
        return modelName;
    }

    public void setModelName(String modelName) {
        this.modelName = modelName;
    }

    public String getSequence() {
        return sequence;
    }

    public void setSequence(String sequence) {
        this.sequence = sequence;
    }


    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public String getStoreAddress() {
        return storeAddress;
    }

    public void setStoreAddress(String storeAddress) {
        this.storeAddress = storeAddress;
    }

    public String getPickUpDate() {
        return pickUpDate;
    }

    public void setPickUpDate(String pickUpDate) {
        this.pickUpDate = pickUpDate;
    }

    public String getFkCompanyId() {
        return fkCompanyId;
    }

    public void setFkCompanyId(String fkCompanyId) {
        this.fkCompanyId = fkCompanyId;
    }

    public String getCompanyName() {
        return companyName;
    }

    public void setCompanyName(String companyName) {
        this.companyName = companyName;
    }

    public String getPickUpAddress() {
        return pickUpAddress;
    }

    public void setPickUpAddress(String pickUpAddress) {
        this.pickUpAddress = pickUpAddress;
    }

    public String getPickUpType() {
        return pickUpType;
    }

    public void setPickUpType(String pickUpType) {
        this.pickUpType = pickUpType;
    }

    public String getTrafficDestination() {
        return trafficDestination;
    }

    public void setTrafficDestination(String trafficDestination) {
        this.trafficDestination = trafficDestination;
    }

    public String getTrafficStarting() {
        return trafficStarting;
    }

    public void setTrafficStarting(String trafficStarting) {
        this.trafficStarting = trafficStarting;
    }

    public String getTrafficFee() {
        return trafficFee;
    }

    public void setTrafficFee(String trafficFee) {
        this.trafficFee = trafficFee;
    }

    public String getTrafficCompany() {
        return trafficCompany;
    }

    public void setTrafficCompany(String trafficCompany) {
        this.trafficCompany = trafficCompany;
    }

    public String getOrderSupport() {
        return orderSupport;
    }

    public void setOrderSupport(String orderSupport) {
        this.orderSupport = orderSupport;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

    public String getCertificationAttachName() {
        return certificationAttachName;
    }

    public void setCertificationAttachName(String certificationAttachName) {
        this.certificationAttachName = certificationAttachName;
    }

    public String getCertificationAttachUrl() {
        return certificationAttachUrl;
    }

    public void setCertificationAttachUrl(String certificationAttachUrl) {
        this.certificationAttachUrl = certificationAttachUrl;
    }

    public String getInvoiceAttachName() {
        return invoiceAttachName;
    }

    public void setInvoiceAttachName(String invoiceAttachName) {
        this.invoiceAttachName = invoiceAttachName;
    }

    public String getInvoiceAttachUrl() {
        return invoiceAttachUrl;
    }

    public void setInvoiceAttachUrl(String invoiceAttachUrl) {
        this.invoiceAttachUrl = invoiceAttachUrl;
    }

    public String getBucketType() {
        return bucketType;
    }

    public void setBucketType(String bucketType) {
        this.bucketType = bucketType;
    }

    public String getProductionDate() {
        return productionDate;
    }

    public void setProductionDate(String productionDate) {
        this.productionDate = productionDate;
    }

    public String getStoreDuration() {
        return storeDuration;
    }

    public void setStoreDuration(String storeDuration) {
        this.storeDuration = storeDuration;
    }

    public String getFinancing() {
        return financing;
    }

    public void setFinancing(String financing) {
        this.financing = financing;
    }

    public String getPayment() {
        return payment;
    }

    public void setPayment(String payment) {
        this.payment = payment;
    }

    public BigDecimal getPickupPrice() {
        return pickupPrice;
    }

    public void setPickupPrice(BigDecimal pickupPrice) {
        this.pickupPrice = pickupPrice;
    }

    public BigDecimal getPartsPrice() {
        return partsPrice;
    }

    public void setPartsPrice(BigDecimal partsPrice) {
        this.partsPrice = partsPrice;
    }

    public String getPartsRemark() {
        return partsRemark;
    }

    public void setPartsRemark(String partsRemark) {
        this.partsRemark = partsRemark;
    }

    public String getPaymentStatus() {
        return paymentStatus;
    }

    public void setPaymentStatus(String paymentStatus) {
        this.paymentStatus = paymentStatus;
    }

    public String getSettle() {
        return settle;
    }

    public void setSettle(String settle) {
        this.settle = settle;
    }

    public String getFreeMaturityDate() {
        return freeMaturityDate;
    }

    public void setFreeMaturityDate(String freeMaturityDate) {
        this.freeMaturityDate = freeMaturityDate;
    }

    public String getFactoryContacts() {
        return factoryContacts;
    }

    public void setFactoryContacts(String factoryContacts) {
        this.factoryContacts = factoryContacts;
    }

    public String getFactoryTel() {
        return factoryTel;
    }

    public void setFactoryTel(String factoryTel) {
        this.factoryTel = factoryTel;
    }

    public String getShuttleContacts() {
        return shuttleContacts;
    }

    public void setShuttleContacts(String shuttleContacts) {
        this.shuttleContacts = shuttleContacts;
    }

    public String getShuttleTel() {
        return shuttleTel;
    }

    public void setShuttleTel(String shuttleTel) {
        this.shuttleTel = shuttleTel;
    }

    public String getTransportCompany() {
        return transportCompany;
    }

    public void setTransportCompany(String transportCompany) {
        this.transportCompany = transportCompany;
    }

    public String getContacts() {
        return contacts;
    }

    public void setContacts(String contacts) {
        this.contacts = contacts;
    }

    public String getTelephone() {
        return telephone;
    }

    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

    public String getDrayLicense() {
        return drayLicense;
    }

    public void setDrayLicense(String drayLicense) {
        this.drayLicense = drayLicense;
    }

    public String getDeliveryAddress() {
        return deliveryAddress;
    }

    public void setDeliveryAddress(String deliveryAddress) {
        this.deliveryAddress = deliveryAddress;
    }

    public String getDriverName() {
        return driverName;
    }

    public void setDriverName(String driverName) {
        this.driverName = driverName;
    }

    public String getDriverTel() {
        return driverTel;
    }

    public void setDriverTel(String driverTel) {
        this.driverTel = driverTel;
    }

    public String getPicture() {
        return picture;
    }

    public void setPicture(String picture) {
        this.picture = picture;
    }

    public BigDecimal getSpecialFee() {
        return specialFee;
    }

    public void setSpecialFee(BigDecimal specialFee) {
        this.specialFee = specialFee;
    }

    public BigDecimal getDeductionFee() {
        return deductionFee;
    }

    public void setDeductionFee(BigDecimal deductionFee) {
        this.deductionFee = deductionFee;
    }

    public String getDeductionRemark() {
        return deductionRemark;
    }

    public void setDeductionRemark(String deductionRemark) {
        this.deductionRemark = deductionRemark;
    }

    public String getAccessoriesRemark() {
        return accessoriesRemark;
    }

    public void setAccessoriesRemark(String accessoriesRemark) {
        this.accessoriesRemark = accessoriesRemark;
    }

    @Override
    public Date getCreateTime() {
        return createTime;
    }

    @Override
    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    @Override
    public Date getUpdateTime() {
        return updateTime;
    }

    @Override
    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }

    public String getDrillDiameter() {
        return drillDiameter;
    }

    public void setDrillDiameter(String drillDiameter) {
        this.drillDiameter = drillDiameter;
    }

    public String getMaxCapacity() {
        return maxCapacity;
    }

    public void setMaxCapacity(String maxCapacity) {
        this.maxCapacity = maxCapacity;
    }

    public String getStockTime() {
        return stockTime;
    }

    public void setStockTime(String stockTime) {
        this.stockTime = stockTime;
    }

    public String getTransportStartTime() {
        return transportStartTime;
    }

    public void setTransportStartTime(String transportStartTime) {
        this.transportStartTime = transportStartTime;
    }

    public String getTransportEndTime() {
        return transportEndTime;
    }

    public void setTransportEndTime(String transportEndTime) {
        this.transportEndTime = transportEndTime;
    }


    public String getCreateUserId() {
        return createUserId;
    }

    public void setCreateUserId(String createUserId) {
        this.createUserId = createUserId;
    }

    public String getCreateUserName() {
        return createUserName;
    }

    public void setCreateUserName(String createUserName) {
        this.createUserName = createUserName;
    }


    public String getUpdateUserId() {
        return updateUserId;
    }

    public void setUpdateUserId(String updateUserId) {
        this.updateUserId = updateUserId;
    }

    public Date getAuditTime() {
        return auditTime;
    }

    public void setAuditTime(Date auditTime) {
        this.auditTime = auditTime;
    }

    public String getAuditRoleName() {
        return auditRoleName;
    }

    public void setAuditRoleName(String auditRoleName) {
        this.auditRoleName = auditRoleName;
    }

    public BigDecimal getTonConfig() {
        return tonConfig;
    }

    public void setTonConfig(BigDecimal tonConfig) {
        this.tonConfig = tonConfig;
    }

    public String getActualDeliveryDate() {
        return actualDeliveryDate;
    }

    public void setActualDeliveryDate(String actualDeliveryDate) {
        this.actualDeliveryDate = actualDeliveryDate;
    }

    public String getProvinceName() {
        return provinceName;
    }

    public void setProvinceName(String provinceName) {
        this.provinceName = provinceName;
    }

    public String getCityName() {
        return cityName;
    }

    public void setCityName(String cityName) {
        this.cityName = cityName;
    }

    public String getCountyName() {
        return countyName;
    }

    public void setCountyName(String countyName) {
        this.countyName = countyName;
    }

    public String getNamePlateAttachName() {
        return namePlateAttachName;
    }

    public void setNamePlateAttachName(String namePlateAttachName) {
        this.namePlateAttachName = namePlateAttachName;
    }

    public String getNamePlateAttachUrl() {
        return namePlateAttachUrl;
    }

    public void setNamePlateAttachUrl(String namePlateAttachUrl) {
        this.namePlateAttachUrl = namePlateAttachUrl;
    }

    public String getDriverAttachName() {
        return driverAttachName;
    }

    public void setDriverAttachName(String driverAttachName) {
        this.driverAttachName = driverAttachName;
    }

    public String getDriverAttachUrl() {
        return driverAttachUrl;
    }

    public void setDriverAttachUrl(String driverAttachUrl) {
        this.driverAttachUrl = driverAttachUrl;
    }

    public String getPartsAttachName() {
        return partsAttachName;
    }

    public void setPartsAttachName(String partsAttachName) {
        this.partsAttachName = partsAttachName;
    }

    public String getPartsAttachUrl() {
        return partsAttachUrl;
    }

    public void setPartsAttachUrl(String partsAttachUrl) {
        this.partsAttachUrl = partsAttachUrl;
    }

    public String getDeviceParts() {
        return deviceParts;
    }

    public void setDeviceParts(String deviceParts) {
        this.deviceParts = deviceParts;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public String getDeviceAnnex() {
        return deviceAnnex;
    }

    public void setDeviceAnnex(String deviceAnnex) {
        this.deviceAnnex = deviceAnnex;
    }

    @Override
    public String getTableName() {
        return "T_DVC_SAMPLE";
    }

    @Override
    public String getViewName() {
        return "V_DVC_SAMPLE_2_REPAYMENT_PLAN";
    }

    @Override
    public JSONObject getJSONObject() {
        JSONObject obj = new JSONObject();
        obj.put("ID", this.getId());
        obj.put("FK_BRAND_ID", this.getFkBrandId());
        obj.put("BRAND_NAME", this.getBrandName());
        obj.put("FK_DEVICE_TYPE_ID", this.getFkDeviceTypeId());
        obj.put("DEVICE_TYPE_NAME", this.getDeviceTypeName());
        obj.put("FK_MODEL_ID", this.getFkModelId());
        obj.put("MODEL_NAME", this.getModelName());
        obj.put("SEQUENCE", this.getSequence());
        obj.put("STATE", this.getState());
        obj.put("STORE_ADDRESS", this.getStoreAddress());
        obj.put("PICK_UP_DATE", this.getPickUpDate());
        obj.put("FK_COMPANY_ID", this.getFkCompanyId());
        obj.put("COMPANY_NAME", this.getCompanyName());
        obj.put("PICK_UP_ADDRESS", this.getPickUpAddress());
        obj.put("PICK_UP_TYPE", this.getPickUpType());
        obj.put("TRAFFIC_DESTINATION", this.getTrafficDestination());
        obj.put("TRAFFIC_STARTING", this.getTrafficStarting());
        obj.put("TRAFFIC_FEE", this.getTrafficFee());
        obj.put("TRAFFIC_COMPANY", this.getTrafficCompany());
        obj.put("ORDER_SUPPORT", this.getOrderSupport());
        obj.put("REMARK", this.getRemark());
        obj.put("CERTIFICATION_ATTACH_NAME",this.getCertificationAttachName());
        obj.put("CERTIFICATION_ATTACH_URL",this.getCertificationAttachUrl());
        obj.put("INVOICE_ATTACH_URL",this.getInvoiceAttachUrl());
        obj.put("NAMEPLATE_ATTACH_NAME",this.getNamePlateAttachName());
        obj.put("NAMEPLATE_ATTACH_URL",this.getNamePlateAttachUrl());
        obj.put("DRIVER_ATTACH_NAME",this.getDriverAttachName());
        obj.put("DRIVER_ATTACH_URL",this.getDriverAttachUrl());
        obj.put("INVOICE_ATTACH_NAME",this.getInvoiceAttachName());
        obj.put("BUCKET_TYPE",this.getBucketType());
        obj.put("PRODUCTION_DATE",this.getProductionDate());
        obj.put("STORE_DURATION",this.getStoreDuration());
        obj.put("FINANCING",this.getFinancing());
        obj.put("PAYMENT",this.getPayment());
        obj.put("PICK_UP_PRICE",this.getPickupPrice());
        obj.put("PARTS_PRICE",this.getPartsPrice());
        obj.put("PARTS_REMARK",this.getPartsRemark());
        obj.put("PAYMENT_STATUS",this.getPaymentStatus());
        obj.put("SETTLE",this.getSettle());
        obj.put("FREE_MATURITY_DATE",this.getFreeMaturityDate());
        obj.put("FACTORY_CONTACTS",this.getFactoryContacts());
        obj.put("FACTORY_TEL",this.getFactoryTel());
        obj.put("SHUTTLE_CONTACTS",this.getShuttleContacts());
        obj.put("SHUTTLE_TEL",this.getShuttleTel());
        obj.put("TRANSPORT_COMPANY",this.getTransportCompany());
        obj.put("CONTACTS",this.getContacts());
        obj.put("TELEPHONE",this.getTelephone());
        obj.put("DRAY_LICENSE",this.getDrayLicense());
        obj.put("DELIVERY_ADDRESS",this.getDeliveryAddress());
        obj.put("DRIVER_NAME",this.getDriverName());
        obj.put("DRIVER_TEL",this.getDriverTel());
        obj.put("PICTURE",this.getPicture());
        obj.put("SPECIAL_FEE",this.getSpecialFee());
        obj.put("DEDUCTION_FEE",this.getDeductionFee());
        obj.put("DEDUCTION_REMARK",this.getDeductionRemark());
        obj.put("CREATE_TIME", createTime);
        obj.put("UPDATE_TIME", updateTime);
        obj.put("DRILL_DIAMETER", this.getDrillDiameter());
        obj.put("MAX_CAPACITY", this.getMaxCapacity());
        obj.put("STOCK_TIME", this.getStockTime());
        obj.put("TRANSPORT_START_TIME", this.getTransportStartTime());
        obj.put("TRANSPORT_END_TIME", this.getTransportEndTime());
        obj.put("AUDIT_NAME", this.getAuditName());
        obj.put("AUDIT_ID", this.getAuditId());
        obj.put("AUDIT_FLAG", this.getAuditFlag());
        obj.put("CREATE_USER_ID", this.getCreateUserId());
        obj.put("CREATE_USER_NAME", this.getCreateUserName());
        obj.put("UPDATE_USER_ID", this.getUpdateUserId());
        obj.put("UPDATE_USER_NAME", this.getUpdateUserName());
        obj.put("AUDIT_ADVISE", this.getAuditAdvise());
        obj.put("AUDIT_ROLE_NAME", this.getAuditRoleName());
        obj.put("AUDIT_TIME", this.getAuditTime());
        obj.put("REGION_ID", this.getRegionId());
        obj.put("REGION_NAME", this.getRegionName());
        obj.put("REGION_MANAGER_ID", this.getRegionManagerId());
        obj.put("REGION_MANAGER_NAME", this.getRegionManagerName());
        obj.put("BIGREGION_MANAGER_ID", this.getBigregionManagerId());
        obj.put("BIGREGION_MANAGER_NAME", this.getBigregionManagerName());
        obj.put("RECENT_CONTACT_DATE", this.getRecentContactDate());
        obj.put("LATEST_WORKING_HOURS", this.getLatestWorkingHours());
        obj.put("DEVICE_SOURCE", this.getDeviceSource());
        obj.put("WARRANTY_STATE", this.getWarrantyState());
        obj.put("ADMINISTRATOR_NAME", this.getAdministratorName());
        obj.put("ADMINISTRATOR_PHONE", this.getAdministratorPhone());
        obj.put("OPERATOR_NAME", this.getOperatorName());
        obj.put("OPERATOR_PHONE", this.getOperatorPhone());
        obj.put("SERVICE_PERSONNEL", this.getServicePersonnel());
        obj.put("ENGINE_NUMBER", this.getEngineNumber());
        obj.put("NEXT_SERVICE_DATE", this.getNextServiceDate());
        obj.put("COOPERATION_TYPE", this.getCooperationType());
        obj.put("TON_CONFIG", this.getTonConfig());
        obj.put("ACTURAL_DELIVERY_DATE", this.getActualDeliveryDate());
        obj.put("PROVINCE_NAME", this.getProvinceName());
        obj.put("CITY_NAME", this.getCityName());
        obj.put("COUNTY_NAME", this.getCountyName());
        obj.put("ACCESSORIES_REMARK", this.getAccessoriesRemark());
        obj.put("PARTS_ATTACH_NAME",this.getPartsAttachName());
        obj.put("PARTS_ATTACH_URL",this.getPartsAttachUrl());
        obj.put("DEVICE_PARTS",this.getDeviceParts());
        obj.put("DESCRIPTION",this.getDescription());
        obj.put("DEVICE_ANNEX",this.getDeviceAnnex());
        return obj;
    }

    @Override
    public JSONObject getJSONColumns() {
        JSONObject obj = new JSONObject();
        obj.put("ID", "id");
        obj.put("FK_BRAND_ID", "fkBrandId");
        obj.put("BRAND_NAME", "brandName");
        obj.put("FK_DEVICE_TYPE_ID", "fkDeviceTypeId");
        obj.put("DEVICE_TYPE_NAME", "deviceTypeName");
        obj.put("FK_MODEL_ID", "fkModelId");
        obj.put("MODEL_NAME", "modelName");
        obj.put("SEQUENCE", "sequence");
        obj.put("STATE", "state");
        obj.put("STORE_ADDRESS", "storeAddress");
        obj.put("PICK_UP_DATE", "pickUpDate");
        obj.put("FK_COMPANY_ID", "fkCompanyId");
        obj.put("COMPANY_NAME", "companyName");
        obj.put("PICK_UP_ADDRESS", "pickUpAddress");
        obj.put("PICK_UP_TYPE", "pickUpType");
        obj.put("TRAFFIC_DESTINATION", "trafficDestination");
        obj.put("TRAFFIC_STARTING", "trafficStarting");
        obj.put("TRAFFIC_FEE", "trafficFee");
        obj.put("TRAFFIC_COMPANY", "trafficCompany");
        obj.put("ORDER_SUPPORT", "orderSupport");
        obj.put("REMARK", "remark");
        obj.put("CERTIFICATION_ATTACH_NAME", "certificationAttachName");
        obj.put("CERTIFICATION_ATTACH_URL", "certificationAttachUrl");
        obj.put("INVOICE_ATTACH_URL", "invoiceAttachUrl");
        obj.put("INVOICE_ATTACH_NAME", "invoiceAttachName");
        obj.put("NAMEPLATE_ATTACH_NAME","namePlateAttachName");
        obj.put("NAMEPLATE_ATTACH_URL","namePlateAttachUrl");
        obj.put("DRIVER_ATTACH_NAME","driverAttachName");
        obj.put("DRIVER_ATTACH_URL","driverAttachUrl");
        obj.put("BUCKET_TYPE", "bucketType");
        obj.put("PRODUCTION_DATE", "productionDate");
        obj.put("STORE_DURATION", "storeDuration");
        obj.put("FINANCING", "financing");
        obj.put("PAYMENT", "payment");
        obj.put("PICK_UP_PRICE", "pickupPrice");
        obj.put("PARTS_PRICE", "partsPrice");
        obj.put("PARTS_REMARK", "partsRemark");
        obj.put("PAYMENT_STATUS", "paymentStatus");
        obj.put("SETTLE", "settle");
        obj.put("FREE_MATURITY_DATE", "freeMaturityDate");
        obj.put("FACTORY_CONTACTS", "factoryContacts");
        obj.put("FACTORY_TEL", "factoryTel");
        obj.put("SHUTTLE_CONTACTS", "shuttleContacts");
        obj.put("SHUTTLE_TEL", "shuttleTel");
        obj.put("TRANSPORT_COMPANY", "transportCompany");
        obj.put("CONTACTS", "contacts");
        obj.put("TELEPHONE", "telephone");
        obj.put("DRAY_LICENSE", "drayLicense");
        obj.put("DELIVERY_ADDRESS", "deliveryAddress");
        obj.put("DRIVER_NAME", "driverName");
        obj.put("DRIVER_TEL", "driverTel");
        obj.put("PICTURE", "picture");
        obj.put("SPECIAL_FEE", "specialFee");
        obj.put("DEDUCTION_FEE", "deductionFee");
        obj.put("DEDUCTION_REMARK", "deductionRemark");
        obj.put("CREATE_TIME", "createTime");
        obj.put("UPDATE_TIME", "updateTime");
        obj.put("DRILL_DIAMETER", "drillDiameter");
        obj.put("MAX_CAPACITY", "maxCapacity");
        obj.put("STOCK_TIME", "stockTime");
        obj.put("TRANSPORT_START_TIME", "transportStartTime");
        obj.put("TRANSPORT_END_TIME", "transportEndTime");

        obj.put("AUDIT_NAME", "auditName");
        obj.put("AUDIT_ID", "auditId");
        obj.put("AUDIT_FLAG", "auditFlag");
        obj.put("CREATE_USER_ID", "createUserId");
        obj.put("CREATE_USER_NAME", "createUserName");
        obj.put("UPDATE_USER_ID", "updateUserId");
        obj.put("UPDATE_USER_NAME", "updateUserName");
        obj.put("AUDIT_ADVISE", "auditAdvise");
        obj.put("AUDIT_ROLE_NAME", "auditRoleName");
        obj.put("AUDIT_TIME", "auditTime");

        obj.put("REGION_ID", "regionId");
        obj.put("REGION_NAME", "regionName");
        obj.put("REGION_MANAGER_ID", "regionManagerId");
        obj.put("REGION_MANAGER_NAME", "regionManagerName");
        obj.put("BIGREGION_MANAGER_ID", "bigregionManagerId");
        obj.put("BIGREGION_MANAGER_NAME", "bigregionManagerName");
        obj.put("RECENT_CONTACT_DATE", "recentContactDate");
        obj.put("LATEST_WORKING_HOURS", "latestWorkingHours");
        obj.put("DEVICE_SOURCE", "deviceSource");
        obj.put("WARRANTY_STATE", "warrantyState");
        obj.put("ADMINISTRATOR_NAME", "administratorName");
        obj.put("ADMINISTRATOR_PHONE", "administratorPhone");
        obj.put("OPERATOR_NAME", "operatorName");
        obj.put("OPERATOR_PHONE", "operatorPhone");
        obj.put("SERVICE_PERSONNEL", "servicePersonnel");
        obj.put("ENGINE_NUMBER", "engineNumber");
        obj.put("NEXT_SERVICE_DATE", "nextServiceDate");
        obj.put("COOPERATION_TYPE", "cooperationType");
        obj.put("TON_CONFIG", "tonConfig");
        obj.put("ACTURAL_DELIVERY_DATE", "actualDeliveryDate");
        obj.put("PROVINCE_NAME", "provinceName");
        obj.put("CITY_NAME",  "cityName");
        obj.put("COUNTY_NAME", "countyName");
        obj.put("ACCESSORIES_REMARK", "accessoriesRemark");
        obj.put("PARTS_ATTACH_NAME","partsAttachName");
        obj.put("PARTS_ATTACH_URL","partsAttachUrl");
        obj.put("DEVICE_PARTS","deviceParts");
        obj.put("DESCRIPTION","description");
        obj.put("DEVICE_ANNEX","deviceAnnex");
        return obj;
    }
}